/**
 * Project: lionbule-other
 * 
 * File Created at 2012-6-5
 * $Id$
 * 
 * Copyright 1999-2100 Alibaba.com Corporation Limited.
 * All rights reserved.
 *
 * This software is the confidential and proprietary information of
 * Alibaba Company. ("Confidential Information").  You shall not
 * disclose such Confidential Information and shall use it only in
 * accordance with the terms of the license agreement you entered into
 * with Alibaba.com.
 */
package lb.test;

/**
 * WriteFile.
 * @author LionBule
 *  2012-6-5 下午4:24:05
 */
public class WriteFile {

    /**
     * @param args
     */
    public static void main(String[] args) {
        for(int i=251;i<501;i++){
            StringBuilder sb = new StringBuilder();
            String tableName = "dkv_d"+String.format("%04d", i);
            sb.append("DROP TABLE IF EXISTS `"+tableName+"`;");
            System.out.println(sb.toString());
        }
        
//        for(int i=1;i<251;i++){
//            StringBuilder sb = new StringBuilder();
//            String tableName = "dkv_d"+String.format("%04d", i);
//            sb.append("CREATE TABLE `").append(tableName).append("` (`customer_id` bigint(10) NOT NULL,`path` int(11) NOT NULL,`property` varchar(64) NOT NULL,`type` tinyint(1) NOT NULL, `value` varchar(4096) DEFAULT NULL,`gmt_create` datetime NOT NULL,`gmt_modify` datetime NOT NULL, UNIQUE KEY `pk` (`customer_id`,`path`,`property`) USING BTREE,KEY `property` (`property`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
//            System.out.println(sb.toString());
//        }
    }

}
